﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_BBS_UpdateItemInfo]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_BBS_UpdateItemInfo];
GO
CREATE PROCEDURE [dbo].[sproc_BBS_UpdateItemInfo]
@item_id    int,
@board_id     int,
@title        nvarchar(300),
@content    ntext,
@sender        nvarchar(50),
@send_time    datetime,
@hit_times    int,
@replay_times    int,
@last_replayer    nvarchar(50),
@last_replay_time    datetime,
@ip        nvarchar(50),
@bulletin    bit,
@sysbulletin    bit,
@desktop    bit
/*-------------------------------------------
功能：修改贴子
参数：
    @board_id    板块id
    @title        标题
    @content    内容
    @sender        发送人
    @send_time    发送时间
    @hit_times    点击次数
    @replay_times    回复次数
    @last_replayer    最后回复人
    @last_replay_time    最后回复次数
    @ip        发贴人ip
    @bulletin    是否板块公告
    @sysbulletin    是否系统公告
    @desktop    桌面提醒
----------------------------------------------*/
AS
    UPDATE uds_bbs_forumItem
    SET 
        board_id = @board_id,
        title =@title,
        content = @content,
        sender = @sender,
        send_time = @send_time,
        hit_times = @hit_times,
        replay_times = @replay_times,
        last_replayer = @last_replayer,
        last_replay_time = @last_replay_time,
        ip = @ip,
        bulletin = @bulletin,
        sysbulletin = @sysbulletin,
        desktop = @desktop
    WHERE     item_id = @item_id